CREATE  TABLE `DSS_LMS`.`Location_User` (  `UserID` DECIMAL(10,0)  NULL ,  `LocationID` DECIMAL(10,0)  NULL ,  `Designation` VARCHAR(45) NULL ,  `Status` VARCHAR(20) NULL ,  INDEX `Loc  ID` (`LocationID` ASC) ,  INDEX `Usr_ID` (`UserID` ASC) ,  CONSTRAINT `Loc  ID`    FOREIGN KEY (`LocationID` )    REFERENCES `dss_lms`.`location` (`LocationID` )    ON DELETE NO ACTION    ON UPDATE NO ACTION,  CONSTRAINT `Usr_ID`    FOREIGN KEY (`UserID` )    REFERENCES `dss_lms`.`user` (`UserID` )    ON DELETE NO ACTION    ON UPDATE NO ACTION);